PersonNamePart

Entity Definition

Logical Name : PersonNamePart
Physical Name : PA_PRS_NM_PART

The finest granularity of a Person Name, which may be formed by more than one word.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
PersonNamePartID (PK) A system generated unique identifier for a part of a Person Name. ID_NM_PRS Identity integer
PersonPartyID (AK)(FK) A unique, system assigned identity for a Party. ID_PRTY_PRS Identity integer PersonName(PA_NM)
EffectiveDate (AK)(FK) The datea person's name is effective. DT_EF EffectiveDate date PersonName(PA_NM)
PersonNameTypeCode (AK)(FK) A code that describes a role that a name part plays in a person's name. For instance, names may comprise given names, family names, middle names, etc. LU_NM_PRS Code6 char(6) PersonNameType(PA_TYP_PRS_NM)
RelativeOrderNumber (AK) A positional number to indicate the relative order of a person's name part within a name type. For instance, if person has two last name parts, then the relative order number would set the order of those name parts within the set of last names. AI_ORD_RLTV Code2 char(2)
PartName The lowest level of granularity of a Person's name. NM_PRS Name varchar(40)

Relationships

Parent Entity Verb Phrase Child Entity
PersonNameType describes PersonNamePart
PersonName includes PersonNamePart

Logical Views containing PersonNamePart

Logical View
Logical 06315 - Party - Person Names View
Logical 06320 - Party - Address and Contact View
Logical 06330 - Party - Identification View
Logical 07010 - Customer Account Information Extended